2012-02-22 - 3766.100 - Enhancement - SA110 & SA115 Report Changes #CrystalReportsSupport

ENHANCEMENT

3766.100 - SA110 & SA115 Report Changes

Requirement Summary

---

Need to include two subreports for SA110 and SA115 reports to show Top 15 countries and Top 5 Customer Channel Groups.

Admin Info

---

Purpose	Need to include 2 subreports for SA110 & SA115 reports.
Requested By	Pete Augustine
Spec Created By	Mallareddy D
Spec Created Date	02/22/2012
Spec QA by	Uday Kumar P
Objects	SA110 & SA115 Reports.
Document Status	Complete

References

---

Prior Tickets

None

Documents

None

Functional Requirement

---

1. Need to create two sub reports which shows Top 15 Countries and Top 5 Customer Channel Groups. They need to be included in the last page of the existing SA110 and SA115 reports.
2. Top 15 Countries need to show in upper portion of the page and Top 5 Customer Channel Groups need to be shown in lower portion of the page.
3. For SA110 report, Top 15 countries and Top 5 Customer Channel Groups need to be shown for all regions based on Current Year YTD Actual Revenue.
4. For SA115 report, Top 15 countries and Top 5 Customer Channel Groups need to be shown for selected region based on Current Year MTD Revenue.
5. Each subreport need to show Current Year MTD, Previous Year MTD, Current Year YTD and Previous Year YTD Actual Revenues.
6. For Subreport Top 5 Customer Channel Groups, If the Customer Channel groups is Brazil, USA and Not Assigned and which listed under Top 5 that needs go under "All Others" section instead of showing it in Top 5.

Solution Summary

---

1. Need to create two reports which shows country wise and Customer Channel Groups wise Current Year YTD, Current Year MTD, Previous Year YTD and Previous Year MTD.
2. Thereafter need to generate the excel files for the developed reports and these excel reports need to be used as a source for the subreports in SA110 and SA115 reports.

Test Plan

SNo.	Test Scenario	Expected Results
1.	Need to check the report values with BEx query	Values should be identical.

Solution Details

---

1. Need to Create two reports for to show Country vise revenue and Customer Channel Groups revenue.
2. Need to generate the excel files from the developed reports and to be saved at "necbiproddatasources".
3. Need to create subreport for Top 15 Countries.
4. Need to create subreport for Top 5 Customer Channel Groups.

Issues

---

None